CPUアーキテクチャを考慮した性能モデルの導入によるデータベース・クエリ最適化のためのコスト計算の精度向上

Non-volatile memory is applied not only to storage subsystems but also to the main memory of computers to improve performance and increase capacity. In the near future, some in-memory database systems will use non-volatile main memory as a durable medium instead of using existing storage devices, such as hard disk drives or solid-state drives. In addition, cloud computing is gaining more attention, and users are increasingly demanding performance improvement. In particular, the Database-as-a-Service (DBaaS) market is rapidly expanding. Attempts to improve database performance have led to the development of in-memory databases using non-volatile memory as a durable database medium rather than existing storage devices. For such in-memory database systems, the cost of memory access instead of Input/Output (I/O) processing decreases, and the Central Processing Unit (CPU) cost increases relative to the most suitable access path selected for a database query. Therefore, a high-precision cost calculation method for query execution is required. In particular, when the database system cannot select the most appropriate join method, the query execution time increases. Moreover, in the cloud computing environment the CPU architecture of different physical servers may be of different generations. The cost model is also required to be capable of application to different generation CPUs through minor modification in order not to increase database administrator\u27s extra duties. To improve the accuracy of the cost calculation, a cost calculation method based on CPU architecture using statistical information measured by a performance monitor embedded within the CPU (hereinafter called measurement-based cost calculation method) is proposed, and the accuracy of estimating the intersection (hereinafter called cross point) of cost calculation formulas for join methods is evaluated. In this calculation method, we concentrate on the instruction issuing part in the instruction pipeline, inside the CPU architecture. The cost of database search processing is classified into three types, data cache access, instruction cache miss penalty and branch misprediction penalty, and for each a cost calculation formula is constructed. Moreover, each cost calculation formula models the tendency between the statistical information measured by the performance monitor embedded within the CPU and the selectivity of the table while executing join operations. The statistical information measured by the performance monitor is information such as the number of executed instructions and the number of cache hits. In addition, for each element separated into elements repeatedly appearing in the access path of the join, cost calculation formulas are formed into parts, and the cost is calculated combining the parts for an arbitrary number of join tables. First, to investigate the feasibility of the proposed method, a cost formula for a two-table join was constructed using a large database, 100 GB of the TPC Benchmark(TM) H database. The accuracy of the cost calculation was evaluated by comparing the measured cross point with the estimated cross point. The results indicated that the difference between the predicted cross point and the measured cross point was less than 0.1% selectivity and was reduced by 71% to 94% compared with the difference between the cross point obtained by the conventional method and the measured cross point. Therefore, the proposed cost calculation method can improve the accuracy of join cost calculation. Then, to reduce the operating time of the database administration, the cost calculation formulawas constructed under the condition that the database for measuring the statistical value was reduced to a small scale (5 GB). The accuracy of cost calculations was also evaluated when joining three or more tables. As a result, the difference between the predicted cross point and the measured cross point was reduced by 74% to 95% compared with the difference between the cross point obtained by the conventional method and the measured cross point. It means the proposed method can improve the accuracy of cost calculation. Finally, a method is also proposed for updating the cost calculation formula using the measurement-based cost calculation method to support a CPU with architecture from another generation without requiring re-measurement of the statistical information of that CPU. Our approach focuses on reflecting architectural changes, such as cache size and associativity, memory latency, and branch misprediction penalty, in the components of the cost calcula-tion formulas. The updated cost calculation formulas estimated the cost of joining different generation-based CPUs accurately in 66% of the test cases. In conclusion, the in-memory database system using the proposed cost calculation method can select the best join method and can be applied to a database system with CPUs from different generations.首都大学東京, 2019-03-25, 博士（工学）首都大学東

Endoscopic Mucosal Resection of Primary Anorectal Malignant Melanoma:A Case Report

Anorectal melanoma is a rare malignant tumor with a poor prognosis. However, several studies have reported cases of long-term survival. In this report, we present a patient with anorectal melanoma who has survived for 9 years after endoscopic mucosal resection. An 85-year-old man was referred to our hospital for further examination and treatment of an anal tumor 2cm in size. Endoscopic ultrasonography revealed that the depth of tumor invasion was confined to the submucosal layer. Endoscopic mucosal resection was performed, and the tumor was diagnosed as a malignant melanoma. The patient was followed without any additional treatment, which was per his wishes. Although melanoma recurred 4 times thereafter, endoscopic mucosal resection was performed for each recurrent lesion. Thus, he has been alive for 9 years since the first endoscopic mucosal resection without distant metastases. If the depth of tumor invasion is shallow, endoscopic mucosal resection is a useful option among other therapeutic modalities.</p

Development of Genome-Wide SNP Markers for Barley via Reference- Based RNA-Seq Analysis

Marker-assisted selection of crop plants requires DNA markers that can distinguish between the closely related strains often used in breeding. The availability of reference genome sequence facilitates the generation of markers, by elucidating the genomic positions of new markers as well as of their neighboring sequences. In 2017, a high quality genome sequence was released for the six-row barley (Hordeum vulgare) cultivar Morex. Here, we developed a de novo RNA-Seq-based genotyping procedure for barley strains used in Japanese breeding programs. Using RNA samples from the seedling shoot, seedling root, and immature flower spike, we mapped next-generation sequencing reads onto the transcribed regions, which correspond to ∼590 Mb of the whole ∼4.8-Gbp reference genome sequence. Using 150 samples from 108 strains, we detected 181,567 SNPs and 45,135 indels located in the 28,939 transcribed regions distributed throughout the Morex genome. We evaluated the quality of this polymorphism detection approach by analyzing 387 RNA-Seq-derived SNPs using amplicon sequencing. More than 85% of the RNA-Seq SNPs were validated using the highly redundant reads from the amplicon sequencing, although half of the indels and multiple-allele loci showed different polymorphisms between the platforms. These results demonstrated that our RNA-Seq-based de novo polymorphism detection system generates genome-wide markers, even in the closely related barley genotypes used in breeding programs

On the Formation and Constitution of Nickel-Ferrite

The authors have studied on the formation, constiution, magnetic properties, and microstructures of Ni-ferrite, and also prepared the single crystals of Ni-ferrite. The intimate mixtures of NiO and Fe₂O₃ powder of various molar ratio were used as raw materials. The samples were heated at various temperature and were investigated by X-ray and magnetic analyses. The main results obtained were as follows. 1) Ni-ferrite is formed from oxides mixture at above 675℃. 2) NiFe₂O₄ dissolves excess NiO and Fe₂O₃ at above 1250° and 1200℃ respectively. At 1300°, the single spinel phase is obtained in the range of Fe₂O₃ content of from 52% to 86.5% in weight. 3) Ni-ferrite which dissolves excess Fe₂O₃ precipitate free Fe₂O₃ by annealing at 700℃ for 3 hours. 4) Ni-ferrite is a ferromagnetic compound and the intensity of magnetization shows a sharp maximum at the 1-2 sample at above 1200℃. The magnetism of the samples containing excess Fe₂O₃ are weakend remarkably by annealing at above 500℃, and this phenomena seems to be connected with precipitation of excess Fe₂O₃. 5) The growth steps are recognized on the crystals which developes on the sintered surface of Ni-ferrite. 6) The lattice constant of Ni-ferrite is about 8.22~8.23Å, and Curie point is about 588℃. 7) Ni-ferrite single crystal forms regular octahedron

Quadrupole moments in chiral material DyFe3(BO3)4 observed by resonant x-ray diffraction

By means of circularly polarized x-ray beam at Dy L3 and Fe K absorption edges, the chiral structure of the electric quadrupole was investigated for a single crystal of DyFe3(BO3)4 in which both Dy and Fe ions are arranged in spiral manners. The integrated intensity of the resonant x- ray diffraction of space-group forbidden reflections 004 and 005 is interpreted within the electric dipole transitions from Dy 2p3 to 5d and Fe 1s to 4p, respectively. We have confirmed that the 2 handedness of the crystal observed at Dy L3 and Fe K edges is consistent with that observed at Dy M5 edge in the previous study. By analyzing the azimuth scans of the diffracted intensity, the electronic quadrupole moments of Dy 5d and Fe 4p are derived. The temperature profiles of the integrated intensity of 004 at the Dy L3 and the Fe K edges are similar to those of Dy-O and Fe-O bond lengths, while that at the Dy M5 edge does not. The results indicate that the helix chiral orientations of quadrupole moments due to Dy 5d and Fe 4p electrons are more strongly affected by the crystal fields than Dy 4f

Edge states of Sr2_2RuO4_4 detected by in-plane tunneling spectroscopy

We perform tunneling spectroscopy of Sr$_2$RuO$_4$ searching for the edge states peculiar to topological superconductivity. Conductance spectra obtained on Sr$_2$RuO$_4$/Au junctions fabricated using $in$ $situ$ process show broad humps indicating the successful detection of a-axis edge of 1.5K phase. Three types of peak shape are detected: domelike peak, split peak and two-step peak. By comparing the experiments with predictions for unconventional superconductivity, these varieties are shown to originate from multiband chiral p-wave symmetry with weak anisotropy of pair amplitude. The broad hump in conductance spectrum is a direct manifestation of the edge state peculiar to the chiral p-wave superconductivity.Comment: 7 pages and 4 figure

ニッチュウ ゼンメン センソウ ショキ ニ オケル モウキョウ セイケン ノ ヨウモウ トウセイ

大阪大學中國文化論壇 討論文件Discussion Papers in Contemporary China Studies, Osaka University Forum on Chin

鏡視下足関節固定術で使用される中空海綿骨螺子による圧着圧の比較

Background: When performing arthroscopic ankle arthrodesis for end-stage ankle arthritis, internal fixation is performed using bone screws after appropriate preparation. However, optimal characteristics of bone screws have not been examined in terms of pressure force. Objective comparisons of bone-screw performance may provide information on procedures for arthroscopic ankle arthrodesis. The study objectives were to determine whether it was possible to measure compressive force changes using the newly developed device and to infer all screw characteristics from measurement results when used in actual surgeries. In addition, we performed experiments on cadavers to verify whether the experimental results could be applied to the joints of living subjects. Methods: Three types of screws (S1, S2, and S3) were inserted into the unique measurement device, and the changes in pressure were measured for each 45° turn. Changes in pressure and maximum pressure force were recorded after the application of the screws. After reaching the maximum pressure in the simulated bone, further screw rotations were accompanied by a gradual pressure decrease to 0 MPa. We also measured pressure changes in a similar manner by inserting a miniature pressure sensor into the talocrural joints of cadavers. Results: The mean maximum pressure ± standard deviation for S1, S2, and S3 were 0.832 ± 0.164 MPa, 0.434 ± 0.116 MPa, and 0.414 ± 0.127 MPa, respectively. Pressure slopes to the maximum did not significantly differ between the screws in the simulated bone, and a subsequent pressure decrease to 0 MPa was significantly more rapid for S1 than for S2 and S3. Although pressure failure after the overtightening of screws was only observed in the simulated bone, patterns of pressure vs. rotation angle were similar in simulated and cadaveric bones. The pressure profile characteristics of three different screw types were determined. Conclusions: We were able to measure the compressive force changes using the newly developed device when the screws were inserted. On the basis of the measurement results, we were able to infer the characteristics of all screws when used in actual surgery.博士（医学）・乙第1403号・平成29年6月28日Copyright © The Author(s). 2017 Open Access This article is distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution, and reproduction in any medium, provided you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license, and indicate if changes were made. The Creative Commons Public Domain Dedication waiver (http://creativecommons.org/publicdomain/zero/1.0/) applies to the data made available in this article, unless otherwise stated

A criterion for determining whether multiple shells support a tt-design

In this paper, we provide a criterion for determining whether multiple shells support a $t$-design. We construct as a corollary an infinite series of $2$-designs using power residue codes.Comment: 16 pages. arXiv admin note: substantial text overlap with arXiv:2309.03206, arXiv:2305.03285, arXiv:2310.1428